{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"ID","type":"number","width":4,"decimals":0},{"name":"PARENTID","type":"number","width":4,"decimals":0},{"name":"INDEX","type":"number","width":4,"decimals":0},{"name":"TYPE","type":"number","width":2,"decimals":0},{"name":"CLIPTYPE","type":"number","width":4,"decimals":0},{"name":"REEL","type":"number","width":2,"decimals":0},{"name":"TITLE","type":"character","width":40},{"name":"TIMEIN","type":"character","width":11},{"name":"TIMEOUT","type":"character","width":11},{"name":"WORDSIN","type":"character","width":75},{"name":"WORDSOUT","type":"character","width":75},{"name":"FILENAME","type":"character","width":40}],"n_rows":160,"rows_kept":160,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"dbase_level_three","encoding_class":"enc_absent","reader":"statdb_count/9"}
[1,0,1,0,null,null,"Introduction",null,null,null,null,null]
[2,1,1,1,null,null,"Spreadsheets",null,null,null,null,null]
[3,2,1,2,257,1,null,"00:01:00:00","00:01:55:00","Hi, I'm","as a spreadsheet","H0001"]
[4,2,2,2,258,1,null,"00:01:55:00","00:03:39:00","you can use","way to others","C0001"]
[5,1,2,1,null,null,"Launch Excel",null,null,null,null,null]
[6,5,1,2,257,1,null,"00:03:39:00","00:03:51:00","everything you do","that appears","H0002"]
[7,5,2,2,259,1,null,"00:03:51:00","00:04:22:00","click start, programs","hide the office assistant","M0001"]
[8,1,3,1,null,null,"Excel Workspace",null,null,null,null,null]
[9,8,1,2,259,1,null,"00:04:22:00","00:06:12:00","now what you see","for the selection","M0002"]
[10,8,2,2,257,1,null,"00:06:12:00","00:06:36:00","the Excel grid","a productive tool","H0003"]
[11,0,2,0,null,null,"Entering Values",null,null,null,null,null]
[12,11,1,1,null,null,"Text Values",null,null,null,null,null]
[13,12,1,2,257,1,null,"00:06:51:00","00:07:14:00","in order to","an excel worksheet","H0004"]
[14,12,2,2,259,1,null,"00:07:14:00","00:08:10:00","start by selecting","are text values","M0003"]
[15,11,2,1,null,null,"Numeric Values",null,null,null,null,null]
[16,15,1,2,259,1,null,"00:08:10:00","00:09:05:00","let's try entering","and press enter","M0004"]
[17,11,3,1,null,null,"AutoFill",null,null,null,null,null]
[18,17,1,2,259,1,null,"00:09:05:00","00:10:00:00","when you have","are left aligned","M0005"]
[19,11,4,1,null,null,"Date Values",null,null,null,null,null]
[20,19,1,2,259,1,null,"00:10:00:00","00:11:27:00","let's try adding","typed the value","M0006"]
[21,11,5,1,null,null,"Format Painter",null,null,null,null,null]
[22,21,1,2,259,1,null,"00:11:27:00","00:12:22:00","Excel allows you","the format change","M0007"]
[23,11,6,1,null,null,"Formatting Dates",null,null,null,null,null]
[24,23,1,2,257,1,null,"00:12:22:00","00:13:09:00","a date in excel","dates in cells","H0005"]
[25,23,2,2,259,1,null,"00:13:09:00","00:14:48:00","if you take","back into a date","M0008"]
[26,11,7,1,null,null,"Edit Cells",null,null,null,null,null]
[27,26,1,2,259,1,null,"00:14:48:00","00:16:34:00","let's enter a couple","back to the cell","M0009"]
[28,11,8,1,null,null,"Sorting Lists",null,null,null,null,null]
[29,28,1,2,259,1,null,"00:16:34:00","00:18:08:00","with values in a","sorting a list","M0010"]
[30,28,2,2,257,1,null,"00:18:08:00","00:18:49:00","when you enter","the selected range","H0006"]
[31,0,3,0,null,null,"Workbooks",null,null,null,null,null]
[32,31,1,1,null,null,"Save",null,null,null,null,null]
[33,32,1,2,257,1,null,"00:19:01:00","00:19:30:00","the grid in which","in excel","H0007"]
[34,32,2,2,259,1,null,"00:19:30:00","00:21:25:00","when you first","and save it","M0011"]
[35,31,2,1,null,null,"Open and Close",null,null,null,null,null]
[36,35,1,2,259,1,null,"00:21:25:00","00:22:19:00","if you then","one workbook left","M0012"]
[37,31,3,1,null,null,"Find",null,null,null,null,null]
[38,37,1,2,259,1,null,"00:22:19:00","00:24:02:00","here's a couple of","of the folder name","M0013"]
[39,31,4,1,null,null,"Favorites",null,null,null,null,null]
[40,39,1,2,259,1,null,"00:24:02:00","00:25:00:00","If you do have","to that folder","M0014"]
[41,31,5,1,null,null,"Worksheets",null,null,null,null,null]
[42,41,1,2,259,1,null,"00:25:00:00","00:27:12:00","within a workbook","most often","M0015"]
[43,31,6,1,null,null,"Manipulating Sheets",null,null,null,null,null]
[44,43,1,2,259,1,null,"00:27:12:00","00:28:46:00","if you want to","this extra worksheet","M0016"]
[45,43,2,2,257,1,null,"00:28:46:00","00:29:24:00","a workbook gives you","changes to a workbook","H0008"]
[46,0,4,0,null,null,"Formatting Cells",null,null,null,null,null]
[47,46,1,1,null,null,"Example",null,null,null,null,null]
[48,47,1,2,257,1,null,"00:29:35:00","00:30:06:00","one of the really","at your company","H0009"]
[49,47,2,2,259,1,null,"00:30:06:00","00:30:30:00","here's an example","create this certificate","M0017"]
[50,46,2,1,null,null,"Enter Values",null,null,null,null,null]
[51,50,1,2,259,1,null,"00:30:30:00","00:31:42:00","let me close","president below it","M0018"]
[52,46,3,1,null,null,"Modify Fonts",null,null,null,null,null]
[53,52,1,2,259,1,null,"00:31:42:00","00:32:53:00","the first thing","new enlarged font size","M0019"]
[54,46,4,1,null,null,"Center Text",null,null,null,null,null]
[55,54,1,2,259,1,null,"00:32:53:00","00:33:18:00","next let's center","this selected text","M0020"]
[56,46,5,1,null,null,"Font Size and Color",null,null,null,null,null]
[57,56,1,2,259,1,null,"00:33:18:00","00:34:10:00","now let's make","color of the date","M0021"]
[58,46,6,1,null,null,"Format Date",null,null,null,null,null]
[59,58,1,2,259,1,null,"00:34:10:00","00:35:10:00","we don't want","formatting to the date","M0022"]
[60,46,7,1,null,null,"Column Width",null,null,null,null,null]
[61,60,1,2,259,1,null,"00:35:10:00","00:36:12:00","notice that excel","in that column","M0023"]
[62,0,5,0,null,null,"Formatting Techniques",null,null,null,null,null]
[63,62,1,1,null,null,"Rows and Columns",null,null,null,null,null]
[64,63,1,2,257,1,null,"00:36:12:00","00:36:34:00","in addition","wide border affect","H0010"]
[65,63,2,2,259,1,null,"00:36:34:00","00:37:57:00","let's create","all selected rows","M0024"]
[66,62,2,1,null,null,"Create Border",null,null,null,null,null]
[67,66,1,2,259,1,null,"00:37:57:00","00:40:08:00","now select one","a signature row","M0025"]
[68,62,3,1,null,null,"Insert Columns",null,null,null,null,null]
[69,68,1,2,257,1,null,"00:40:07:00","00:40:35:00","the certificate","above the signatures","H0011"]
[70,68,2,2,259,1,null,"00:40:35:00","00:41:28:00","first we need to","column border","M0026"]
[71,62,4,1,null,null,"Copy and Paste Cells",null,null,null,null,null]
[72,71,1,2,259,1,null,"00:41:28:00","00:42:29:00","now we need to","signatures properly","M0027"]
[73,62,5,1,null,null,"Merge Cells",null,null,null,null,null]
[74,73,1,2,259,1,null,"00:42:29:00","00:43:54:00","as you can see","the finished certificate","M0028"]
[75,73,2,2,257,1,null,"00:43:54:00","00:44:18:00","excel allows you","that selected range","H0012"]
[76,0,6,0,null,null,"Summarizing Numbers",null,null,null,null,null]
[77,76,1,1,null,null,"Tab Entry",null,null,null,null,null]
[78,77,1,2,257,1,null,"00:44:30:00","00:45:00:00","the original purpose","within the company","H0013"]
[79,77,2,2,259,1,null,"00:45:00:00","00:47:30:00","first name a new","within a grid","M0029"]
[80,76,2,1,null,null,"AutoSum",null,null,null,null,null]
[81,80,1,2,259,1,null,"00:47:30:00","00:48:14:00","now we need","and the region","M0030"]
[82,76,3,1,null,null,"Grand Totals",null,null,null,null,null]
[83,82,1,2,259,1,null,"00:48:14:00","00:50:40:00","now let's see","at this time","M0031"]
[84,76,4,1,null,null,"Custom Formulas",null,null,null,null,null]
[85,84,1,2,257,1,null,"00:50:40:00","00:51:06:00","excel's autosum","of your own","H0014"]
[86,84,2,2,259,1,null,"00:51:06:00","00:53:46:00","suppose for example","a special need","M0032"]
[87,84,3,2,257,1,null,"00:53:46:00","00:54:14:00","Excel's autosum","in your spreadsheet","H0015"]
[88,0,7,0,null,null,"Formatting Numbers",null,null,null,null,null]
[89,88,1,1,null,null,"Currency Style",null,null,null,null,null]
[90,89,1,2,257,1,null,"00:01:00:00","00:01:21:00","once you've added","to interpret","H0016"]
[91,89,2,2,259,1,null,"00:01:21:00","00:02:05:00","suppose that you have","to other calls","M0033"]
[92,88,2,1,null,null,"Format Currency Style",null,null,null,null,null]
[93,92,1,2,259,1,null,"00:02:05:00","00:03:45:00","notice that when you","number dialog box","M0034"]
[94,88,3,1,null,null,"AutoFormat Region",null,null,null,null,null]
[95,94,1,2,257,1,null,"00:03:45:00","00:04:14:00","when you have","of the table","H0017"]
[96,94,2,2,259,1,null,"00:04:14:00","00:06:47:00","in the workbook","of their sections","M0035"]
[97,88,4,1,null,null,"Current Region",null,null,null,null,null]
[98,97,1,2,259,1,null,"00:06:47:00","00:07:49:00","notice however","of more space","M0036"]
[99,97,2,2,257,1,null,"00:07:49:00","00:08:19:00","whenever you have","totals and headings","H0018"]
[100,0,8,0,null,null,"Creating Charts",null,null,null,null,null]
[101,100,1,1,null,null,"Copy Worksheet",null,null,null,null,null]
[102,101,1,2,257,1,null,"00:08:28:00","00:08:50:00","one of the most","how to do that","H0019"]
[103,101,2,2,259,1,null,"00:08:50:00","00:09:30:00","let's say that you","to be sales chart","M0037"]
[104,100,2,1,null,null,"Chart Wizard",null,null,null,null,null]
[105,104,1,2,259,1,null,"00:09:30:00","00:10:34:00","we can delete","we'll look at later","M0038"]
[106,100,3,1,null,null,"Add to Chart",null,null,null,null,null]
[107,106,1,2,259,1,null,"00:10:34:00","00:12:43:00","notice here that","and press delete","M0039"]
[108,100,4,1,null,null,"Chart Orientation",null,null,null,null,null]
[109,108,1,2,259,1,null,"00:12:13:00","00:13:44:00","let's try a different","inappropriate orientation","M0040"]
[110,100,5,1,null,null,"Chart Type",null,null,null,null,null]
[111,110,1,2,257,1,null,"00:13:44:00","00:14:02:00","even after you","you would like","H0020"]
[112,110,2,2,259,1,null,"00:14:02:00","00:14:57:00","on the charted","chart to look like","M0041"]
[113,100,6,1,null,null,"Chart Location",null,null,null,null,null]
[114,113,1,2,259,1,null,"00:14:57:00","00:16:33:00","if you hold the mouse","to the table","M0042"]
[115,113,2,2,257,1,null,"00:16:33:00","00:16:58:00","charts in excel","the charting menu","H0021"]
[116,0,9,0,null,null,"Printing",null,null,null,null,null]
[117,116,1,1,null,null,"Print Preview",null,null,null,null,null]
[118,117,1,2,257,1,null,"00:17:10:00","00:17:46:00","then years ago","how to do that","H0022"]
[119,117,2,2,259,1,null,"00:17:46:00","00:18:37:00","many times before","with the mouse pointer","M0043"]
[120,116,2,1,null,null,"Page Setup",null,null,null,null,null]
[121,120,1,2,259,1,null,"00:18:37:00","00:20:06:00","directly from print","at the top","M0044"]
[122,116,3,1,null,null,"Margins",null,null,null,null,null]
[123,122,1,2,259,1,null,"00:20:06:00","00:21:16:00","if you want","print preview itself","M0045"]
[124,116,4,1,null,null,"Page Layout",null,null,null,null,null]
[125,124,1,2,259,1,null,"00:21:16:00","00:22:25:00","the problem with","to the workbook","M0046"]
[126,116,5,1,null,null,"Black & White Printing",null,null,null,null,null]
[127,126,1,2,259,1,null,"00:22:25:00","00:23:15:00","on the sales","return to the workbook","M0047"]
[128,116,6,1,null,null,"View Multiple Sheets",null,null,null,null,null]
[129,128,1,2,259,1,null,"00:23:15:00","00:24:00:00","so far each time","sheet in turn","M0048"]
[130,116,7,1,null,null,"Modify Multiple Sheets",null,null,null,null,null]
[131,130,1,2,259,1,null,"00:24:00:00","00:24:47:00","even as you","one active sheet","M0049"]
[132,116,8,1,null,null,"Print Sheets",null,null,null,null,null]
[133,132,1,2,259,1,null,"00:24:47:00","00:25:49:00","one thing you should","all of the sheets","M0050"]
[134,0,10,0,null,null,"Customizing Excel",null,null,null,null,null]
[135,134,1,1,null,null,"Options",null,null,null,null,null]
[136,135,1,2,257,1,null,"00:26:49:00","00:27:21:00","microsoft excel contains","it to work","H0023"]
[137,135,2,2,259,1,null,"00:27:21:00","00:28:45:00","many of the","default file location","M0051"]
[138,134,2,1,null,null,"Windows in Taskbar",null,null,null,null,null]
[139,138,1,2,259,1,null,"00:28:45:00","00:29:28:00","back on the view menu","windows and taskbar optoin","M0052"]
[140,134,3,1,null,null,"Adaptive Menus",null,null,null,null,null]
[141,140,1,2,257,1,null,"00:29:28:00","00:30:01:00","as you've noticed","for your use","H0024"]
[142,140,2,2,259,1,null,"00:30:03:00","00:30:54:00","to turn off","without having to pause","M0053"]
[143,134,4,1,null,null,"Toolbars",null,null,null,null,null]
[144,143,1,2,259,1,null,"00:30:54:00","00:33:18:00","now let's look","frequently used commands","M0054"]
[145,134,5,1,null,null,"Context Toolbar",null,null,null,null,null]
[146,145,1,2,259,1,null,"00:33:18:00","00:34:35:00","one other thing","context sensitive toolbar","M0055"]
[147,145,2,2,257,1,null,"00:34:35:00","00:35:26:00","menus are","that particular toolbar","H0025"]
[148,0,11,0,null,null,"Discovering More",null,null,null,null,null]
[149,148,1,1,null,null,"Clues",null,null,null,null,null]
[150,149,1,2,257,1,null,"00:36:00:00","00:36:22:00","excel has","about excel features","H0026"]
[151,149,2,2,259,1,null,"00:36:22:00","00:38:20:00","one of the most","or hide different toolbars","M0056"]
[152,148,2,1,null,null,"Help",null,null,null,null,null]
[153,152,1,2,259,1,null,"00:38:20:00","00:39:16:00","one of the most","working in excel","M0057"]
[154,148,3,1,null,null,"Office Assistant",null,null,null,null,null]
[155,154,1,2,259,1,null,"00:39:16:00","00:40:09:00","the office assistant","for the assistant","M0058"]
[156,148,4,1,null,null,"Expanded Help",null,null,null,null,null]
[157,156,1,2,259,1,null,"00:40:09:00","00:41:11:00","let's go back","of related topics","M0059"]
[158,148,5,1,null,null,"Docking Help",null,null,null,null,null]
[159,158,1,2,259,1,null,"00:41:11:00","00:42:11:00","even without","of your monitor","M0060"]
[160,158,2,2,257,1,null,"00:42:11:00","00:43:11:00","excel is","features themselves","H0027"]